Long-Run Cash Rent Spreadsheet Tool

by Michael Langemeier

Updated October 2025

This spreadsheet uses enterprise budget information, projected yields, and projected prices to examine breakeven prices, earnings per acre, breakeven cash rents, and trends in working capital.

Farmers typically find that rental rates don’t adjust rapidly during a downturn and consequently they lose money on rented land. But most farmers don’t want to give up rented land even if it is not profitable because it is difficult to find another parcel to replace it. They continue to hold on to rented land waiting for better prices, lower costs, and/or higher yields. The fundamental question is how long can they delay the decision. In other words, when should they hold them and when should they fold them? This question has become even more relevant today, given the financial pressure currently faced by crop producers across the Corn Belt, including lower commodity prices, tighter margins, and higher interest rates. Read more on using the spreadsheet tool here!

TAGS:

TEAM LINKS:

RELATED RESOURCES

Liquidity and Repayment Capacity

October 1, 2026

Purdue analysis of FINBIN data shows how liquidity and repayment capacity have differed across crop farm sizes from 2007 to 2025, with notable changes in the gap between smaller and larger farms.

2026 Cash Rents: Why Aren’t Rents Falling More?

September 10, 2026

Cash rents have softened in some parts of Indiana in 2026, but overall, rents remain relatively stable. So why aren’t they falling more, even after several years of weaker returns to land? Michael Langemeier and Todd Kuethe examine the latest cash rent results from the 2026 Purdue Farmland Values and Cash Rents Survey and look at what the numbers could mean for 2027.

2026 Trends in Farmland Price to Rent Ratios in Indiana

September 9, 2026

Indiana farmland values remain elevated relative to the cash rent they generate. Purdue agricultural economist Michael Langemeier examines what the farmland price-to-rent ratio can tell us about land values, future returns and the risks facing buyers.

UPCOMING EVENTS

Weathering Water Extremes: Connecting Soil Health, Drainage, Irrigation, and Farm Resilience

Join educators from across the Midwest to build skills for communicating soil health concepts on Nov. 4-5, 2026. In the field, we’ll evaluate the relationship between soil health and water management focusing on irrigation and edge of field practices. The in-service will have both classroom and on farm demonstrations.

Land of Opportunity: A Conference for Farmland Owners!

The Land of Opportunity: A Conference for Farmland Owners will be held at two locations on October 5 and October 6, providing farmland owners with valuable information and resources to help them make informed decisions about their land. The conference will feature keynote presentations, educational breakout sessions, and networking opportunities designed specifically for those who own, manage, or have an interest in farmland.